UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xmWBEpxuGKYfnTDKvG0iHkwV+FIykezYblr1aKqFUf8='
WHERE
key_id = '39279e1b5598a91fab88361b86df85b812ca351a2923ba86dac85a9d392af9bb'
AND (
token = 'xmWBEpxuGKYfnTDKvG0iHkwV+FIykezYblr1aKqFUf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)