UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YHebkynzuJr3bJiR58tWMV6/UV0a9sANyPZPdO85N6Y='
WHERE
key_id = 'b9b3f22d5e9b8c2be4cbfc5fb7de4983d1380f516a91b9e5147ffc9d20bc1d3f'
AND (
token = 'YHebkynzuJr3bJiR58tWMV6/UV0a9sANyPZPdO85N6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)