UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hiKPG6OVyAYjeW9wcnqHBpZgMEuBCl9Feir6KYJWNH0='
WHERE
key_id = '482da0d967dd81b66e5ec598deb1bfc3b95739824778a236dcf3d48fbba978cf'
AND (
token = 'hiKPG6OVyAYjeW9wcnqHBpZgMEuBCl9Feir6KYJWNH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)