UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6/dGRf+iOwI2co8HgonZVyxkpgYfuGlChzi/o3NbfB8='
WHERE
key_id = 'a41fba47678651b32b89571090b4b250f89b1ddf42800bfc903910e4490706f3'
AND (
token = '6/dGRf+iOwI2co8HgonZVyxkpgYfuGlChzi/o3NbfB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)