UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+9WknyApgh+jzukjHqqwVZw0djDoRB0TvDzdIhX6yBY='
WHERE
key_id = '0fd467307234365394bebd828962d2a706726c70cab23e5e431ca8951490fd63'
AND (
token = '+9WknyApgh+jzukjHqqwVZw0djDoRB0TvDzdIhX6yBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)