UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6M5HrxeXbpEBEM6OUnIHMx41304Mk1jyGIZJk5jKHM='
WHERE
key_id = '076d6732c2cacdfa0716d0f14a7d6c3ad26aa0fc597c9b50796f833b4f8d8437'
AND (
token = 'C6M5HrxeXbpEBEM6OUnIHMx41304Mk1jyGIZJk5jKHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)