UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CPNE4RW4KZkF6AFnQjbfByUmH1gfRvCErPyfyc3IvyM='
WHERE
key_id = 'e0ee0a0a4d99e660242b90f1e8029d357c5a927386e818d839555aed4b090cd3'
AND (
token = 'CPNE4RW4KZkF6AFnQjbfByUmH1gfRvCErPyfyc3IvyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)