UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jlpAw0zPPQftGOn8bjNnPFdUWEu0Nb717B0epc2kgc='
WHERE
key_id = '9a87bb1e4c7276b1ca2174c7fb701611881f3f32521b2af49a160643f6d7b94d'
AND (
token = '4jlpAw0zPPQftGOn8bjNnPFdUWEu0Nb717B0epc2kgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)