UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9A5kiFxDr5CcJRQBtzso2Oep3hagLuxTwNRyIcwUiY8='
WHERE
key_id = '5abbd06a8e27b65bb27956f3a8b063d34e53adfb4b08d843571c3029097f0ddb'
AND (
token = '9A5kiFxDr5CcJRQBtzso2Oep3hagLuxTwNRyIcwUiY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)