UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vRh0/HAVikR9THTi1FItvdIO11vWLa1AbyShk4JPtVg='
WHERE
key_id = '5fad97e16b084b1b97d602e1c84646e7219e6e638e38ddeefc4efbdc42b68420'
AND (
token = 'vRh0/HAVikR9THTi1FItvdIO11vWLa1AbyShk4JPtVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)