UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '96BZGjy5QBA8vntw18gfnmEIM1jpr0qU1B6ifGtryVU='
WHERE
key_id = '018bb59b0201a7e379597ed5420fd665649214be68bd1bb3f628b344735a9396'
AND (
token = '96BZGjy5QBA8vntw18gfnmEIM1jpr0qU1B6ifGtryVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)