UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4LbnamfDKLxtHZr6EhA5J9pZAT/r9djU9rRd55KVLc='
WHERE
key_id = 'c1c0c23805996ee93765919fbcbc9f07469b50960c1728f16949290ede233527'
AND (
token = 'G4LbnamfDKLxtHZr6EhA5J9pZAT/r9djU9rRd55KVLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)