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