UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WLzHcTQSbcX4NmrSEEyx8rUq4G8GGi42z9y02jryyus='
WHERE
key_id = '767c9159e35abf1373b4a0e7f33bf2652977c2803fe15406e24e0b63a07818f0'
AND (
token = 'WLzHcTQSbcX4NmrSEEyx8rUq4G8GGi42z9y02jryyus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)