UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XD9WF5kMOC3RST1lZW0QTsSsDIC42tbaZ6fRbmPYYYU='
WHERE
key_id = '9797f316a2fcfd22baea80a17b6bd27d038128117b8ea14eb5414ab3ed099464'
AND (
token = 'XD9WF5kMOC3RST1lZW0QTsSsDIC42tbaZ6fRbmPYYYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)