UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1rzcPkIyOwZr/zacR8YswTPZJq7+nAYs/ofevnFL3wA='
WHERE
key_id = '747c284a42893ae9d716dfb0c69fc0ffc059d1ea47816af4050665a22545c213'
AND (
token = '1rzcPkIyOwZr/zacR8YswTPZJq7+nAYs/ofevnFL3wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)