UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCWclSh4yDCE+jKd0ylEtd61t2dYfFV84ayPEtM0BWY='
WHERE
key_id = 'a0c533cb3a1d5d142f531dd212ba605ee4db09f3b3eea3b6d837cc83bb358798'
AND (
token = 'HCWclSh4yDCE+jKd0ylEtd61t2dYfFV84ayPEtM0BWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)