UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tatKrv7RTH0e2DphK6OGvH3L4N5Wk5ziS6jPb1xJ5Cg=' 
WHERE 
  key_id = '1eefc08391701fce9306111cb85be7f19a7ad4583d4e5dea440b6e41da59995f' 
  AND (
    token = 'tatKrv7RTH0e2DphK6OGvH3L4N5Wk5ziS6jPb1xJ5Cg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035