UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '596zBgC00OU8kEn54Cw3KImx8qjgThuHVao9KNYwO2E='
WHERE
key_id = '9ad56c347cab87d513be5c766c566fe95c5217b48ad8ecc47aadc085fc5740da'
AND (
token = '596zBgC00OU8kEn54Cw3KImx8qjgThuHVao9KNYwO2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)