UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C2SznPGJpZwlY/y5Dbhj6sjrgOF17sdAcyp4NcxgIQo='
WHERE
key_id = 'fd76e42773e5dcc81e60fceb73ce3b638e50f7174211a62d5aabd3792b9034b5'
AND (
token = 'C2SznPGJpZwlY/y5Dbhj6sjrgOF17sdAcyp4NcxgIQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)