UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tGIg2C9fHEtvbL1VlX6zuJIs8red5P0So42+Y17FfT8='
WHERE
key_id = 'ec19a0b58d2623a096ac1b9f5d5d2720d8ffd4037ce966229f6c59bd65f84e2a'
AND (
token = 'tGIg2C9fHEtvbL1VlX6zuJIs8red5P0So42+Y17FfT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)