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