UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Xm5fjamHWlHm39cX9H/mU5W3egzuzEJrBn7nVP5JIY='
WHERE
key_id = 'fad785c331f3042a38ca3451624910c138111402edbf1a8c557c092433d2ffb7'
AND (
token = '7Xm5fjamHWlHm39cX9H/mU5W3egzuzEJrBn7nVP5JIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)