UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XST7pdwvCdz6tNw343nHmhnB+loFfjO01eVCo0E4bLQ='
WHERE
key_id = 'c3802ca1a8ed1d07d13013f644d5f9784ef552e1900a8e2c9cddd808c501cd6b'
AND (
token = 'XST7pdwvCdz6tNw343nHmhnB+loFfjO01eVCo0E4bLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)