UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fLPQStRWI4z5Yj8yj3WGqPHSUIDUIrdl6rIBG4nYyZ0='
WHERE
key_id = '34e3bf945389a5bff1fac15002aea20ffbaa4a95c36d0f2e7cdf609f26fc2798'
AND (
token = 'fLPQStRWI4z5Yj8yj3WGqPHSUIDUIrdl6rIBG4nYyZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)