UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIJudBdTF+EsTSEi4CUNFxtyo7ftoSKKkD9aJ82mXlA='
WHERE
key_id = 'a2745b95c5859e3655033a3e5edde8d5fbe5fc9f94b973c5cbbcb63e71abc2d1'
AND (
token = 'gIJudBdTF+EsTSEi4CUNFxtyo7ftoSKKkD9aJ82mXlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)