UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hovbVZ9Ck1TnqXFjSEaWofJMUtJTf8sCWS68l68itXA='
WHERE
key_id = '3e2f851c699aab29c2c0d56895c6feb21b23866283b7f9e122d3f32e182a1fec'
AND (
token = 'hovbVZ9Ck1TnqXFjSEaWofJMUtJTf8sCWS68l68itXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)