UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5c6XtkZzj1hhmAHbrXJCvWmUu5FVhMddWfse8g8Dlsc='
WHERE
key_id = '999f8bf7746501407d832ea0bae70ec498f575a3a5ec5d94696f7bc9e5f79c83'
AND (
token = '5c6XtkZzj1hhmAHbrXJCvWmUu5FVhMddWfse8g8Dlsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)