UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oyngNOk3uUGMI0peVnhmLWcId2lgaxEY/A3J9zAAVQk='
WHERE
key_id = '9e8ad4aadabe45597e442f12af9b79b2da0cefd8f4373cbfcd5aea4645bf2c37'
AND (
token = 'oyngNOk3uUGMI0peVnhmLWcId2lgaxEY/A3J9zAAVQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)