UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '73nG2QLA6shcNpf5VU6jmin0Z3aFUILD1tcU/SdNLj0='
WHERE
key_id = 'b9a7dc59bfb23b43afcffd798eb31e8e23d103418d0a13b1a2a0e627425565cd'
AND (
token = '73nG2QLA6shcNpf5VU6jmin0Z3aFUILD1tcU/SdNLj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)