UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P9UcNpKRwlD0CJyAbKyOrnbbeRkadMkO4L523x5k4Fg='
WHERE
key_id = '102e6cd327a19debf2b1dc93ce3f71abf50cd07e2255728b4fb554be41e55487'
AND (
token = 'P9UcNpKRwlD0CJyAbKyOrnbbeRkadMkO4L523x5k4Fg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)