UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZ7zd60/2ysM15YyuW8Hi5uRzexp80jyI8/ojLl7DVg='
WHERE
key_id = '5493e07707083df72acf5e233b8fde1fed53c0d45e7c2f52c8902cd4893d955f'
AND (
token = 'LZ7zd60/2ysM15YyuW8Hi5uRzexp80jyI8/ojLl7DVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)