UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXjKxG+/RPm8zgZca0+X0TENNQtPRPYb5S7vcRv/R/E='
WHERE
key_id = 'e3a1f1ce8be0279239d788a7768ac7b122af2e3619ec0dd45af7e7ff4f53222a'
AND (
token = 'TXjKxG+/RPm8zgZca0+X0TENNQtPRPYb5S7vcRv/R/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)