UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5NjvpLd2c+ukZHI3GuvOySYRZtKieCjQW24qSxqwU/g='
WHERE
key_id = '92bb3a2dc31d17d97f47e1eef914020c6a4976e960793a09e53b1889bbe79eed'
AND (
token = '5NjvpLd2c+ukZHI3GuvOySYRZtKieCjQW24qSxqwU/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)