UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xW/Xl38pvbeZbqQZiTnc+lqekSuhEiCTGEzWOCl4jvk='
WHERE
key_id = 'f6fb80c0689abbe8d80c16eb1fd021b29d2588f8bc70a005dd2eed8cabd897fc'
AND (
token = 'xW/Xl38pvbeZbqQZiTnc+lqekSuhEiCTGEzWOCl4jvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)