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