UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8XRHF5BXKBGLABP3zake0okcZztzWj7t2s7jM6WzBE='
WHERE
key_id = 'ac04e46f361ee48f39a2038fef910a083d53c7422f77379f5280ef6246296efa'
AND (
token = 'a8XRHF5BXKBGLABP3zake0okcZztzWj7t2s7jM6WzBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)